﻿CREATE TRIGGER UserMessages_Tracking_Update
ON [dbo].[UserMessages] 
AFTER Update
AS 
BEGIN
	UPDATE Sync.UserMessages_Tracking 
	SET LastUpdatedDate  = getdate()
    FROM Sync.UserMessages_Tracking s JOIN INSERTED i
    ON s.UserMessageID = i.UserMessageID
END





